README for apiary_final

Each row in the dataset represents one location (lat/long). Sometimes there were multiple hives inspected with the same lat/long and registration id recorded. Values were averaged across the hives to get a mean Varroa intensity for the apiary.

Variables in the dataset are: 

Latitude

Longitude

Inspection_Date:  YYYY-MM-DDTHH:MM:SSZ

Year: YYYYday_of_year: counting from Jan 1

mean_varroa: mean intensity of Varroa mites at hives inspected at this location (mites/300 bees)

sum_varroa: sum of the recorded intensities

n: number of hives inspected at this location. 

x_m, y_m: Easting/Northing coordinates in meters. Converted from Lat/Long to NAD83(NSRS2007) / Illinois East (epsg: 3528)

x_km/y_km: Easting/Northing coordinates in km, used for spatial regression modeling.

Month: month of inspection date

montrt: categorical variable indicating monitor and treat (mon), treat only (Trt only), or neither. (none)

Insecticide: Beescape insecticide value

Nesting: Beescape nesting value

SpringFloral, SummerFloral, FallFloral: Beescape floral value

TrapezoidAverage: weight average of floral (see paper for definition)

n_apiaries_5km: Number of registered apiaries within 5km. 


